package com.woniu.user.mapper;

import com.woniu.user.pojo.PickAddress;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 * 收货地址表 Mapper 接口
 * </p>
 *
 * @author LiFangyu
 * @since 2023-02-15
 */
public interface PickAddressMapper extends BaseMapper<PickAddress> {
    @Select("SELECT * FROM t_user , t_pick_address WHERE t_user.id = t_pick_address.user_id AND t_user.phone = #{username}")
    List<PickAddress> selectAllByUsername(String username);
}
